Overview

A Table View definition for the Windows Application Spreadsheet Tool or Excel Add-In is defined in a Business Rule.  The Administrator designing the rule can define the rows and columns which should be returned to the worksheet from the source table presented in the Table View.

The Table View Business Rule can collect data from multiple data sources. For example, a single worksheet can display a Table View which collects data from two or more sources.

The Administrator has full control over the write back “save” process through Business Rules. When designing the Table View Business Rule, the BRAPI Authorization functions should be designed into the Business Rule to control access to the viewing or modifying the data. This can be applied to the entire table or to specific cells. A workbook can contain multiple Table Views. These can be on the same worksheet or across worksheet pages.

A single Business Rule file can be used to define multiple Table Views by calling the Business Rule argument, TableViewName. Additionally, a single named range can be used to manage table data cells within the Spreadsheet and Excel Add-In using user defined named ranges (XFTV_*).